package com.stadium.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.stadium.bean.User;

public interface UserRepository extends JpaRepository<User, Integer> {
	
	User getByAccount(String account);
	
	@Query("SELECT u FROM User u where u.role in(0,1,2,3) AND u.status=0")
	List<User> getAll();
}
